library(tidyverse)
library(plotly)
RESEARCH_HOME = "/home/and/Documents/PhD/Research/"
FILES_PATH = "Scripts/R/Benchmarks/MultiAndSingleNode/R12/dblab/"
MONITOR_FILE = "monitor.log"
NOHUP_FILE = "nohup.out"
SEPARATOR_ID = "-"
lines = readLines(paste0(RESEARCH_HOME, FILES_PATH, NOHUP_FILE))
lines = lines[grepl("\\|[1-6]\\.", lines)]
nohup = as_tibble(lines) %>%
separate(value, into=c("Timestamp", "ID", "Time", "Stage", "Duration", "Load", "TS"), sep="\\|") %>%
separate(ID, into=c(NA, NA, "ID"), sep = SEPARATOR_ID) %>%
mutate(ID = as.numeric(ID), Time = as.numeric(Time), Duration = as.numeric(Duration))
Calling `as_tibble()` on a vector is discouraged, because the behavior is likely to change in the future. Use `tibble::enframe(name = NULL)` instead.
[90mThis warning is displayed once per session.[39m
nohupStages = nohup %>% mutate(Stage = paste0(TS,".",str_trim(Stage))) %>%
mutate(Start = Time - Duration, End = Time) %>%
select(ID, Stage, Start, End, Duration)
nohupTimeintervals = nohup %>% select(ID, TS, Time, Duration) %>%
mutate(Start = Time - Duration, End = Time) %>%
group_by(ID, TS) %>% summarise(Start = min(Start), End = max(End))
checkF <- function(ID, Stage, TS, Time, Start, End){
check = Start < Time && Time < End
x <- as_tibble(check)
}
getStageStart <- function(d){
join = d %>% left_join(nohupTimeintervals, by = "ID")
checks = join %>% select(ID, Stage, TS, Time, Start, End) %>% pmap_dfr(checkF)
starts = cbind(join, checks) %>% filter(value) %>%
mutate(Stage = paste0(TS,".",Stage)) %>%
select(Stage, Nodes, Time, y) %>%
group_by(Stage, Nodes) %>%
summarise(Start=min(Time), y=min(y)) %>% arrange(Start)
return(starts)
}
lines = readLines(paste0(RESEARCH_HOME, FILES_PATH, MONITOR_FILE))
Warning message:
Unknown or uninitialised column: 'head'.
lines = lines[grepl("\\|SCALE\\|", lines)]
monitor = as_tibble(lines) %>%
separate(value, into=c("Timestamp", "Scale", "Time", "ID", "Nodes", "StageID", "Stage", "RDDs", "Task", "Dura", "Load"), sep="\\|") %>%
separate(ID, into=c(NA, NA, "ID"), sep = SEPARATOR_ID) %>%
select(ID, Time, Nodes, StageID, Stage, RDDs, Task, Load) %>%
mutate(ID=as.numeric(ID), Time=as.numeric(Time), StageID = as.numeric(StageID), RDDs=as.numeric(RDDs), Tasks=as.numeric(Task), Load=as.numeric(Load)) %>%
group_by(ID, Time, Nodes, StageID, Stage) %>% summarise(RDDs=mean(RDDs), Tasks=mean(Tasks), Load=mean(Load)) %>%
filter(StageID != -1)
monitor$Nodes = (monitor$ID %% 3) + 1
head(monitor)
apps = monitor %>% ungroup() %>% select(ID, Nodes) %>% distinct()
head(apps, n=Inf)
d = monitor %>% filter(ID %in% c(0,1,2)) %>% ungroup %>%
mutate(y = Load, Nodes = factor(Nodes)) %>%
select(ID, Time, y, Nodes, Stage) %>%
arrange(Time)
stageStarts =getStageStart(d)
p = ggplot(data = d, aes(x = Time, y = y, group = 1, color = Nodes, linetype = Nodes)) +
geom_line() +
geom_point(data = stageStarts, aes(x=Start, y=y, group=1, color=Nodes, text = paste(Stage,"<br>Start:",Start,"<br>",y)))
Ignoring unknown aesthetics: text
ggplotly(p, tooltip = c("text"))
LS0tCnRpdGxlOiAiUiBOb3RlYm9vayIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKYGBge3J9CmxpYnJhcnkodGlkeXZlcnNlKQpsaWJyYXJ5KHBsb3RseSkKClJFU0VBUkNIX0hPTUUgPSAiL2hvbWUvYW5kL0RvY3VtZW50cy9QaEQvUmVzZWFyY2gvIgpGSUxFU19QQVRIID0gIlNjcmlwdHMvUi9CZW5jaG1hcmtzL011bHRpQW5kU2luZ2xlTm9kZS9SMTIvZGJsYWIvIgpNT05JVE9SX0ZJTEUgPSAibW9uaXRvci5sb2ciCk5PSFVQX0ZJTEUgPSAibm9odXAub3V0IgpTRVBBUkFUT1JfSUQgPSAiLSIKCmxpbmVzID0gcmVhZExpbmVzKHBhc3RlMChSRVNFQVJDSF9IT01FLCBGSUxFU19QQVRILCBOT0hVUF9GSUxFKSkKbGluZXMgPSBsaW5lc1tncmVwbCgiXFx8WzEtNl1cXC4iLCBsaW5lcyldCm5vaHVwID0gYXNfdGliYmxlKGxpbmVzKSAlPiUKICBzZXBhcmF0ZSh2YWx1ZSwgaW50bz1jKCJUaW1lc3RhbXAiLCAiSUQiLCAiVGltZSIsICJTdGFnZSIsICJEdXJhdGlvbiIsICJMb2FkIiwgIlRTIiksIHNlcD0iXFx8IikgJT4lCiAgc2VwYXJhdGUoSUQsIGludG89YyhOQSwgTkEsICJJRCIpLCBzZXAgPSBTRVBBUkFUT1JfSUQpICU+JQogIG11dGF0ZShJRCA9IGFzLm51bWVyaWMoSUQpLCBUaW1lID0gYXMubnVtZXJpYyhUaW1lKSwgRHVyYXRpb24gPSBhcy5udW1lcmljKER1cmF0aW9uKSkgCiAgCm5vaHVwU3RhZ2VzID0gbm9odXAgJT4lIG11dGF0ZShTdGFnZSA9IHBhc3RlMChUUywiLiIsc3RyX3RyaW0oU3RhZ2UpKSkgJT4lCiAgbXV0YXRlKFN0YXJ0ID0gVGltZSAtIER1cmF0aW9uLCBFbmQgPSBUaW1lKSAlPiUKICBzZWxlY3QoSUQsIFN0YWdlLCBTdGFydCwgRW5kLCBEdXJhdGlvbikgCgpub2h1cFRpbWVpbnRlcnZhbHMgPSBub2h1cCAlPiUgc2VsZWN0KElELCBUUywgVGltZSwgRHVyYXRpb24pICU+JQogIG11dGF0ZShTdGFydCA9IFRpbWUgLSBEdXJhdGlvbiwgRW5kID0gVGltZSkgJT4lCiAgZ3JvdXBfYnkoSUQsIFRTKSAlPiUgc3VtbWFyaXNlKFN0YXJ0ID0gbWluKFN0YXJ0KSwgRW5kID0gbWF4KEVuZCkpCgpjaGVja0YgPC0gZnVuY3Rpb24oSUQsIFN0YWdlLCBUUywgVGltZSwgU3RhcnQsIEVuZCl7IAogIGNoZWNrID0gU3RhcnQgPCBUaW1lICYmIFRpbWUgPCBFbmQKICB4IDwtIGFzX3RpYmJsZShjaGVjaykgCn0KCmdldFN0YWdlU3RhcnQgPC0gZnVuY3Rpb24oZCl7CiAgam9pbiA9IGQgJT4lIGxlZnRfam9pbihub2h1cFRpbWVpbnRlcnZhbHMsIGJ5ID0gIklEIikKICBjaGVja3MgPSBqb2luICU+JSBzZWxlY3QoSUQsIFN0YWdlLCBUUywgVGltZSwgU3RhcnQsIEVuZCkgJT4lIHBtYXBfZGZyKGNoZWNrRikKICBzdGFydHMgPSBjYmluZChqb2luLCBjaGVja3MpICU+JSBmaWx0ZXIodmFsdWUpICU+JSAKICAgIG11dGF0ZShTdGFnZSA9IHBhc3RlMChUUywiLiIsU3RhZ2UpKSAlPiUKICAgIHNlbGVjdChTdGFnZSwgTm9kZXMsIFRpbWUsIHkpICU+JSAKICAgIGdyb3VwX2J5KFN0YWdlLCBOb2RlcykgJT4lIAogICAgc3VtbWFyaXNlKFN0YXJ0PW1pbihUaW1lKSwgeT1taW4oeSkpICU+JSBhcnJhbmdlKFN0YXJ0KQogIHJldHVybihzdGFydHMpCn0KCgpgYGAKCmBgYHtyfQpsaW5lcyA9IHJlYWRMaW5lcyhwYXN0ZTAoUkVTRUFSQ0hfSE9NRSwgRklMRVNfUEFUSCwgTU9OSVRPUl9GSUxFKSkKbGluZXMgPSBsaW5lc1tncmVwbCgiXFx8U0NBTEVcXHwiLCBsaW5lcyldCm1vbml0b3IgPSBhc190aWJibGUobGluZXMpICU+JQogIHNlcGFyYXRlKHZhbHVlLCBpbnRvPWMoIlRpbWVzdGFtcCIsICJTY2FsZSIsICJUaW1lIiwgIklEIiwgIk5vZGVzIiwgIlN0YWdlSUQiLCAiU3RhZ2UiLCAiUkREcyIsICJUYXNrIiwgIkR1cmEiLCAiTG9hZCIpLCBzZXA9IlxcfCIpICU+JQogIHNlcGFyYXRlKElELCBpbnRvPWMoTkEsIE5BLCAiSUQiKSwgc2VwID0gU0VQQVJBVE9SX0lEKSAlPiUKICBzZWxlY3QoSUQsIFRpbWUsIE5vZGVzLCBTdGFnZUlELCBTdGFnZSwgUkREcywgVGFzaywgTG9hZCkgJT4lCiAgbXV0YXRlKElEPWFzLm51bWVyaWMoSUQpLCBUaW1lPWFzLm51bWVyaWMoVGltZSksIFN0YWdlSUQgPSBhcy5udW1lcmljKFN0YWdlSUQpLCBSRERzPWFzLm51bWVyaWMoUkREcyksIFRhc2tzPWFzLm51bWVyaWMoVGFzayksIExvYWQ9YXMubnVtZXJpYyhMb2FkKSkgJT4lCiAgZ3JvdXBfYnkoSUQsIFRpbWUsIE5vZGVzLCBTdGFnZUlELCBTdGFnZSkgJT4lIHN1bW1hcmlzZShSRERzPW1lYW4oUkREcyksIFRhc2tzPW1lYW4oVGFza3MpLCBMb2FkPW1lYW4oTG9hZCkpICU+JQogIGZpbHRlcihTdGFnZUlEICE9IC0xKQptb25pdG9yJE5vZGVzID0gKG1vbml0b3IkSUQgJSUgMykgKyAxCmhlYWQobW9uaXRvcikKYGBgCgpgYGB7cn0KYXBwcyA9IG1vbml0b3IgJT4lIHVuZ3JvdXAoKSAlPiUgc2VsZWN0KElELCBOb2RlcykgJT4lIGRpc3RpbmN0KCkKaGVhZChhcHBzLCBuPUluZikKYGBgCgoKYGBge3J9CmQgPSBtb25pdG9yICU+JSBmaWx0ZXIoSUQgJWluJSBjKDAsMSwyKSkgJT4lIHVuZ3JvdXAgJT4lIAogIG11dGF0ZSh5ID0gTG9hZCwgTm9kZXMgPSBmYWN0b3IoTm9kZXMpKSAlPiUKICBzZWxlY3QoSUQsIFRpbWUsIHksIE5vZGVzLCBTdGFnZSkgJT4lIAogIGFycmFuZ2UoVGltZSkgCgpzdGFnZVN0YXJ0cyA9Z2V0U3RhZ2VTdGFydChkKQoKCmBgYAoKYGBge3J9CnAgPSBnZ3Bsb3QoZGF0YSA9IGQsIGFlcyh4ID0gVGltZSwgeSA9IHksIGdyb3VwID0gMSwgY29sb3IgPSBOb2RlcywgbGluZXR5cGUgPSBOb2RlcykpICsKICBnZW9tX2xpbmUoKSArCiAgZ2VvbV9wb2ludChkYXRhID0gc3RhZ2VTdGFydHMsIGFlcyh4PVN0YXJ0LCB5PXksIGdyb3VwPTEsIGNvbG9yPU5vZGVzLCB0ZXh0ID0gcGFzdGUoU3RhZ2UsIjxicj5TdGFydDoiLFN0YXJ0LCI8YnI+Iix5KSkpCmBgYAoKYGBge3J9CmdncGxvdGx5KHAsIHRvb2x0aXAgPSBjKCJ0ZXh0IikpCmBgYAoKCg==